package com.xyzisme76.dao;
import com.xyzisme76.pojo.*;
import java.util.List;
/**
 * <p>s(sno, sName，sex，age，dept)
 * 表中属性分别为：学号、姓名、性别、年龄和系</p>
 * <Strong>  sno primaryKey
 <hr>
 <Strong>  sName
 <hr>
 <Strong>  sex
 <hr>
 <Strong>  age
<hr>
 <Strong>  dept
 * */
public interface StudentDao {

    List<Student> getStudentList();

    Student getStudentBySno(String  sno);
    // select * from user where name = #{name}(sql)
    Student getStudentBySName(String SName);
    //select * from user where pwd = #{pwd}(sql)

    //同上
    int addStudent(Student student);
    int deleteStudentById(String sno);
    int updateStudent(Student student);
}
